﻿CREATE TABLE [dbo].[tblLocation] (
    [LocationID]       INT            IDENTITY (1, 1) NOT NULL,
    [ShortName]        NVARCHAR (20)  NOT NULL,
    [ParentLocationID] INT            NULL,
    [LocationTypeCode] CHAR (1)       NOT NULL,
    [Active]           BIT            NOT NULL,
    [AddressID]        INT            NULL,
    [LongName]         NVARCHAR (100) NULL
);

